<?php 
require "DataLoad.php"; 
?>
<!DOCTYPE html PUBLIC "-//W3C//Dth XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/Dth/xhtml1-transitional.dth">


<html>
<head>
<title><?php echo $GuildName;?> - DKP系统</title>
<script language="JavaScript" src="inc/jquery.js"></script>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<meta name="Generator" content="EditPlus">
<meta name="Author" content="SULei">
<meta name="Keywords" content="DKP WOW GUILD">
<meta name="Description" content="">
<link href="<?php echo $StylePath;?>/main.css" rel="stylesheet" type="text/css" />
<script language="JavaScript" src="<?php echo $StylePath;?>/styleplus.js"></script>
<style type="text/css" media="all">

</style>
<!--#include file="inc/ajax.php"-->
</head>

<body>
<div class="header">
<?php require "menu.php"; ?>
</div>
<div class="main">
<?php 
Looted();
?>
</div>
<?php require "footer.php"; ?>
</body>
</html>
<?php 
function Looted() {
	extract($GLOBALS);

	if ($_POST["keyword"]!="") {

		$sql="select * from raid_event where event_class='拾取' and event_object2 like '%".$_POST["keyword"]."%' order by event_time";
	}
		else
	if (${"keyword"}!="") {

		$sql="select * from raid_event where event_class='拾取' and event_object2 like '%".${"keyword"}."%' order by event_time";
	}
		else
	{

		$sql="select * from raid_event where event_class='拾取' order by event_time";
	} 

	$result = mysql_query($sql);$sql  $conn
	$HtmlLooted=$HtmlLooted."<table class='outframe interlace'>";
	$HtmlLooted=$HtmlLooted."<tr><th colspan='6'><div class='title'><img src='images/icon/axe.jpg'/>物品拾取记录[共搜索到 ".$result->recordcount." 件]</div><div class='filter'><form method='post' action=''><a href='?'>全部</a><input type='text' name='keyword' value='' /><input type='submit' value='搜索' /></form></div></th></tr>";
	$HtmlLooted=$HtmlLooted."<tr class='coltitle'><td>图</td><td>物品</td><td>拾取者</td><td>DKP</td><td>活动</td><td>日期</td></tr>";
	if ($result->eof || $result->bof) {

		$HtmlLooted=$HtmlLooted."<tr><td colspan='6'>暂无物品记录</td></tr>";
	}
		else
	{

		for ($i=1; $i<=$result->recordcount; $i=$i+1) {
			$HtmlLooted=$HtmlLooted."<tr><td>".eqpic($result["event_object2"],$result["event_object2_tooltip"])."</td><td>".delItemID($result["event_object2"])."</td><td>".id2name($result["event_object"])."</td><td>".$result["event_dkp"]."</td><td>活动</td><td>".$result["event_time"]."</td></tr>";
			$result->movenext;

		}

	} 

	$HtmlLooted=$HtmlLooted."</table>";

	print $HtmlLooted;
	$result->close;
	return $function_ret;
} 
?>
